SUPPORT / SAMPLES & SAS NOTES
Problem Note 54422: The SAS® Customer Experience Analytics LOAD_SESSION_ATTRIBUTION and LOAD_FORM_DETAIL jobs fail
 |  |  |  |  |
The two jobs LOAD_SESSION_ATTRIBUTION and LOAD_FORM_DETAIL assume that the sequence numbers are less than 999 in the following columns:
BUSINESS_PROCESS_X_EXCEPTION.UNSUCCESSFUL_ATTEMPT_INDEX_NO FORM_DETAIL.CHANGE_INDEX_NO SESSION_ATTRIBUTION.SEQUENCE_NO
This assumption is generally valid because larger sequence numbers are generally the result of automated clicks rather than the human-driven data that we intend to gather. If the sequence numbers exceed 999, these two jobs fail.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After the hot fix is applied, rows in which these sequence values exceed 999 are discarded when you run LOAD_SESSION_ATTRIBUTION or LOAD_FORM_DETAIL.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 6.1 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Linux for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Solaris for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||